SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519040 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519040 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474449,92540,442671,973279,178209,9859,270574,327834,886198,883941,207860,61655,838249,1032893,886048,908211,912873,656822,904678,112522,144925,1006397,49329,293784,302461,200203,842551,743998,140717,866160,264190,344457,334564,845340,576866,122254,747902,178175,234231,878244,526010,796176,257850,256149,232144,462923,426117,259123,805575,826579,368751,7671,90566,128215,30255,844560,926491,782980,691883,474610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003452s ]