SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456604 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456604 [ RunTime:0.004394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930853,173254,920812,920939,1028032,759229,298009,452964,32273,421045,366185,351503,935862,982109,250466,608996,733136,15598,181415,183910,1046201,800800,910836,623950,1019143,868467,364900,156701,14365,641134,225134,315847,407459,336284,608091,819557,252320,93836,78436,503121,938850,111390,841755,43610,264266,897376,842878,829033,444303,951331,490621,295059,578917,677657,586412,988025,151595,854417,273656,838356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]