SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265217 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265217 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57577,581829,976210,449873,616207,240270,235595,269020,598191,801843,892846,391590,566578,326709,967808,707703,855611,309111,560087,137731,259579,290815,878643,619771,160846,314186,886052,187301,31478,1028975,875839,975694,389089,418404,154920,412701,185691,585797,847462,920251,124744,411549,707570,473171,792502,796128,326811,153597,131809,714593,839988,272931,647203,903070,368316,670902,332533,535054,397473,321824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]