SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332423 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332423 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6196,662093,496582,63841,664762,736113,702974,720542,1037150,201240,1018021,319825,289379,31341,351397,891358,116684,413417,840722,626086,907230,971073,622525,246525,719465,1012515,934832,86594,1014550,642775,367391,60668,39585,587496,978509,941483,875991,1035537,230167,199674,55185,66233,845737,195629,270716,497233,438334,703766,388658,976686,39248,844549,751133,549912,26140,735085,1037958,891500,979103,597922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]