SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001925s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4381 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4381 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981688,156074,957750,99037,977891,907495,147899,336680,524607,10873,145250,320153,290693,284629,722545,442790,839015,78264,1005708,516476,274175,513778,406288,964212,847774,552173,377466,75813,841110,11334,553721,1012191,702614,695894,883306,210542,853223,179915,690822,46123,35129,361985,587640,854679,316194,1035135,858572,804730,847645,765832,1023068,66440,991184,636117,969266,724593,69837,396963,426882,67308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]