SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019737 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019737 [ RunTime:0.004412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320006,794661,234133,360218,771768,601340,143575,571793,439659,401332,52137,727267,87497,552960,433673,188941,866362,52364,292453,670202,471995,801734,196595,108206,299029,89499,23428,635008,210664,919357,1036919,856878,360270,626298,545874,464412,932063,253394,645150,842018,141051,946199,307406,6266,95158,556012,317467,42566,470997,466371,648373,411949,989905,210556,907517,692830,21703,461623,990792,735481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019737 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019737 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003137s ]