SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012849 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012849 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394796,378595,1029840,1012918,1031609,491892,926775,163742,211382,755965,1022570,141078,396621,454495,884056,536201,108564,44076,138716,67418,414834,273117,524996,924336,562848,624707,794064,302812,865883,1023587,682398,962858,990537,500690,321807,210526,220333,95166,721703,181521,737259,507781,98949,938824,864484,827506,802119,508274,259133,799390,415768,103918,520991,100990,520405,735196,745083,698685,551329,473881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012849 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012849 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]