SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341020 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341020 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969641,341789,424742,1048672,574833,212549,476907,693569,406963,480588,254034,42007,501392,665836,338237,647695,408968,497851,221996,164828,298667,876083,28942,469419,951156,554198,783673,628646,471102,502478,982687,435815,466590,554731,935018,993841,558138,802056,861150,100033,591147,558292,603828,830527,993448,93078,754950,249928,34229,53497,398297,503583,34245,900105,996504,542072,685029,567722,932323,299354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]