SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501259 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501259 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392438,36924,311140,421779,1047686,687245,229777,495090,930141,14665,452317,463886,683853,913795,741068,734624,189419,643111,246200,977541,420635,798140,523001,786525,107906,799109,869153,169623,932835,552950,338032,229217,919930,490793,593696,736342,884765,930275,426061,152877,865057,65975,969025,389047,737728,398643,349425,770910,481072,924548,652394,768643,94787,74951,71949,301861,623309,8787,329344,297713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]