SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430082 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430082 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6045,507200,906117,237824,704140,472063,1023595,634421,671292,560002,218440,711104,847877,584978,806221,26298,212121,827200,19541,805163,259852,10784,366316,264977,789934,565011,216361,468508,749730,985021,142226,632784,318475,716222,734914,299586,130106,740562,730677,903054,448598,592059,763498,590303,918799,777589,661118,271439,775953,386197,228577,814942,190116,72866,236386,861275,20789,994454,753621,665183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]