SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009411 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009411 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267798,670678,309871,993185,344958,809535,1004949,378716,75082,66897,397788,996985,239436,80600,534320,27868,543754,727346,383389,645540,415810,968556,315373,951276,826847,262274,943341,667994,1012212,582554,1030450,321513,368843,916875,750226,1046636,555686,603981,145308,735496,3547,81474,561824,374936,498490,5345,331603,905049,969169,732389,1004228,808209,565169,25935,481778,291921,625354,389769,167597,117578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]