SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53668 LIMIT 1 [ RunTime:0.006959s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53668 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882387,508614,916351,452528,779133,258097,805020,153828,245606,382252,310218,196819,1041518,183476,374929,923210,1033096,457139,252580,463887,600282,382362,44146,662772,465586,548453,218141,538382,889556,690600,657887,428914,772472,1001554,322403,215191,29042,310797,726619,425756,991497,281174,708512,566833,421768,711236,336458,48696,130386,734599,868647,941327,420649,448519,428304,696128,318369,954325,87995,274706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]