SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105533 LIMIT 1 [ RunTime:0.003482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105533 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697625,1008150,691792,850181,977411,615172,908729,163718,502060,1037219,353130,699257,1001604,139228,311896,379161,267008,147459,38647,954449,329869,595629,801695,623957,944732,182303,173356,328139,569586,572892,426595,396672,284897,967884,172384,848690,557604,657794,653202,190709,122994,894833,637543,621407,388395,709681,855594,988547,148959,426756,703564,428124,891055,378663,290088,574932,742928,770486,471311,15921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]