SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72738 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72738 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424128,1012035,644145,300089,415180,477217,370745,1023920,82880,625141,77169,430840,319797,302438,537600,501670,1037594,233740,283919,404472,679345,266811,854720,98388,568146,115344,681076,366809,120212,419596,683097,812444,883929,275668,164821,764279,771766,286175,418811,662037,713979,138739,731128,820546,563702,481822,564453,813307,204183,365223,948291,869982,1009170,10389,209651,588894,839158,904651,553729,399039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]