SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40751 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40751 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454259,696105,246899,655079,840356,132892,830454,74994,403734,840463,16360,382216,716369,626715,875282,467184,20414,380420,73818,332756,491237,760755,67622,462637,570145,957332,950164,451686,541980,975496,768241,109393,667058,857304,1006355,148725,671646,872192,948669,507398,242665,934979,85438,140535,634693,190205,225382,753438,220482,925890,850862,631778,550786,514143,901454,33833,39997,859136,820150,119113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]