SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491103 LIMIT 1 [ RunTime:0.000742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491103 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005526,748516,439115,144470,765711,823202,284432,1043965,689315,599919,536426,953518,281813,181639,485689,771619,418471,249170,504999,143795,607524,731176,18999,255588,2995,839532,210697,310891,714069,724746,7039,1015616,31937,206239,178170,100745,513279,382110,572294,1048292,209044,581411,390380,689406,1034418,160853,853075,715580,780550,889420,525029,868900,983164,119084,69470,367215,282873,800413,211749,39452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]