SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474313 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474313 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003837,132770,484643,976728,361602,96228,815190,755708,512772,1022377,69068,22503,1031389,310470,468780,27352,991485,727249,703244,404028,1020462,1000986,742224,1014965,859243,476852,1038087,769141,375456,278664,535137,784943,971451,473063,419979,948080,415659,773390,594864,450060,992129,741406,396231,612617,726696,181810,1042559,808043,819366,567069,121122,357163,681885,602930,798297,523334,20227,1004519,753335,623247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]