SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524528 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524528 [ RunTime:0.003147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628396,11367,58752,338754,62352,170863,940561,492565,389562,994417,652007,609148,879712,80849,90966,648865,777994,763818,97555,1013510,808772,307498,946344,758013,38455,506483,38943,744198,8114,616134,1031531,449988,132474,425014,818724,1027009,200337,688529,858604,387419,973623,519970,849025,661888,502093,663964,783562,377447,963489,606196,769057,243650,206811,882125,344199,682569,873819,416014,782515,228324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]