SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80613 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80613 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897623,606517,475108,758220,460281,908752,457547,564432,462736,548923,731551,898288,414482,990078,696290,944692,290686,76918,402674,161661,964815,110724,921679,265715,976057,115049,134298,79399,584849,433538,965322,460822,595502,189092,7699,118140,438461,804006,961925,438032,165937,64498,97027,798235,22756,360279,825857,655947,282189,728823,593541,386980,556438,372044,900132,998335,573722,657940,388610,986415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]