SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 826528 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 826528 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83896,94227,548438,621814,50410,330762,938028,146344,289444,798182,636176,15612,322971,370066,965642,38580,770720,749139,315785,471273,207399,722494,913320,294608,1035311,527585,540922,663963,147726,122948,571040,610295,647861,686268,839945,203502,1021812,140267,38360,201344,1045505,814585,186354,639899,402685,622335,665573,729423,452177,273008,850147,859513,52538,684542,53961,957958,711155,729501,502767,340993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 826528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 826528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]