SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 928943 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 928943 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182814,145310,630056,197220,577120,844288,267462,412478,240027,914610,34903,534759,789466,266893,361687,286174,410988,632261,50105,141699,76071,163136,614502,355882,288785,170475,142050,297820,773277,522203,708892,964261,617804,49915,393397,274304,1016791,464511,24381,98045,429171,846247,97590,601839,353768,499584,221273,535797,804325,951210,558756,45415,120488,757015,569040,175813,278692,687489,106296,669301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 928943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 928943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001338s ]