SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519031 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519031 [ RunTime:0.004384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528155,837169,651370,943331,1040128,538767,363739,82316,430478,740772,895278,1000672,996718,807539,559755,448733,576813,26637,729430,116984,310008,822804,602234,1043535,948824,125840,520350,585188,638840,219400,480918,68227,23857,200600,379587,1044720,880082,557865,706187,198204,46979,691198,906501,154391,629075,159324,914609,20105,204923,148511,251438,827539,83923,394611,983366,257316,305999,60884,106723,544379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]