SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422453 LIMIT 1 [ RunTime:0.002720s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422453 [ RunTime:0.007295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4787,804805,89981,155046,692988,189230,305295,927971,1041606,452449,841850,1010046,336454,507023,23898,912103,185933,657858,631735,495270,927814,120944,38383,673314,564792,685490,944312,741302,815838,680057,1015511,616043,443745,643366,377048,607057,755090,607015,1014961,133788,143692,876272,869565,1026738,414624,458284,415621,842815,392249,116132,321010,125225,393173,439511,1014040,408125,664345,234993,585828,801162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001540s ]