SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971367 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971367 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738052,809372,883735,503083,916954,594793,1008878,82283,1029191,489055,183951,129100,368088,983811,249720,909973,975444,264639,370010,968779,995969,797609,362295,182638,234181,645682,486931,1033754,1008351,543035,324693,973838,241208,352173,50333,673605,977762,555518,907083,67912,411293,245510,1029142,806449,79429,346208,164350,818037,1034860,269384,741276,298504,314856,263791,891305,1009475,558551,343122,305028,142950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971367 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971367 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]