SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007941 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007941 [ RunTime:0.004888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445157,343070,138477,539834,221435,665451,937998,844135,722005,705022,96568,912831,369078,149607,246107,22595,840614,637398,1004584,25193,47670,968944,129348,148806,582745,711157,192381,343329,120563,857812,529967,534879,681881,335974,569713,447807,401314,583878,153943,863585,105843,193146,686062,279780,976292,650336,206651,545051,453982,279578,869694,1030455,44082,984794,47388,841775,820599,347983,946006,422826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]