SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109583 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109583 [ RunTime:0.002506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225950,447071,50197,648708,444243,193912,854651,627882,433397,76078,952171,308887,799113,787900,363632,883181,193741,497593,834489,699444,791071,954680,279952,279712,983985,494039,341927,129325,917638,279266,1014068,356566,1040350,142447,9572,248480,909878,440088,687258,6272,1045102,1009312,566149,929209,106693,905760,311576,137322,99590,230311,127169,677962,216521,404321,210489,611656,167324,564859,985396,275434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]