SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415461 LIMIT 1 [ RunTime:0.000704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415461 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38617,183900,111154,279104,1015201,463177,138516,919421,450831,545032,839268,164078,966494,1027746,397413,938474,325103,184340,263375,189719,291152,220060,891003,120923,638778,83073,742501,851877,168384,13448,563020,754973,996855,533253,904398,290400,39571,374796,605217,536063,953114,531505,1028702,91460,975280,585549,166356,305428,963724,660845,947703,210927,969867,349423,446048,197700,944976,528538,903740,81116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]