SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3518 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3518 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469171,971782,1000359,679002,549770,469563,212892,504942,454372,305932,110780,574060,458849,368734,708260,166765,421838,628446,1008914,891572,17797,1015602,1046260,11961,335657,535732,666903,263282,358646,373370,425137,277265,119999,635531,868773,335189,594382,613763,994541,901002,95781,636704,608333,444921,365918,949879,540747,172135,436013,335921,773219,222536,511827,770837,864107,780992,564924,266253,863443,322093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]