SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009241 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009241 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620298,285535,448358,576571,822846,142308,248563,628541,667168,210390,851069,848773,240468,36862,176812,1015355,773714,150274,773473,659478,562577,539105,261855,904924,654605,601052,275929,242549,634063,655044,172979,479824,179344,314249,1041577,1040142,742915,285752,149212,352857,852383,641465,486919,947348,935724,389498,316939,89002,29615,505981,593439,490987,321721,147408,715305,576254,16718,436481,120283,256221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001134s ]