SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545198 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545198 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038855,515363,363253,213524,405738,217934,175342,140859,551673,929202,157687,418676,675662,859623,358312,659162,385614,48142,421136,782945,78856,508378,687932,476027,551196,779545,955664,835576,896915,466219,107307,418268,707069,362589,822835,25862,7021,710326,342026,664478,197175,412853,615079,356865,957929,409685,104726,242168,372037,920161,870805,1006288,94575,745471,137549,479888,65143,153166,756910,492018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]