SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002794s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454198 LIMIT 1 [ RunTime:0.002163s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454198 [ RunTime:0.001436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376466,67401,1038722,470612,918882,104507,132588,676340,1042401,419837,713670,731443,212077,949074,298668,669267,108564,425463,416769,338585,309550,507236,923401,440173,302122,287644,303193,206051,965889,17892,441659,369641,1046661,225338,608092,846174,342730,237065,675711,82014,159840,327928,750912,909752,341574,984579,959353,390513,246043,406144,172641,558629,348794,948743,653480,694398,280862,633824,583939,75224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.016830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000872s ]