SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683197 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683197 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013898,952168,333597,9381,780897,681420,1019323,805225,348383,435832,391364,921221,33768,509577,1036292,790171,166846,973500,715628,116498,971900,941585,25738,705334,814500,694032,854663,246728,618978,677595,240113,233639,953377,570379,771088,433811,567700,363195,701081,495304,556383,271519,634967,237591,284399,819100,215406,559891,734298,1040467,418574,93688,767933,374882,995769,343778,99389,453350,193658,959836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]