SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318159 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318159 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807340,389438,170774,114704,391883,481630,787036,650158,428028,407671,197989,367866,713045,682060,799831,615179,398740,150749,981423,275940,398398,246658,159794,816241,134713,154792,536326,967335,895831,466808,622547,1017834,4523,1032260,853376,555709,453951,564778,777257,61172,467895,231477,213703,241785,549254,561685,190209,148719,325483,355840,73912,193950,645395,567998,734311,224485,848075,432427,820408,910748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001202s ]