SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489014 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489014 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267733,353654,697194,18466,103073,1000994,703975,332404,681322,879661,657610,160054,595942,464992,234907,552825,49004,813380,153981,1019552,402423,813579,28642,63722,245790,772091,132152,527096,882978,21476,542748,540311,771143,259393,787849,573489,337260,144019,588357,349426,600710,1023678,117066,41098,841503,332381,486978,16442,768250,120799,827966,817967,261133,198256,652721,1016604,178299,272790,182129,1009664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]