SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463704 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463704 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778908,632041,944251,376460,430262,733681,841780,776204,152497,986228,237941,300881,101839,448255,464606,446350,1045504,243808,670596,975870,613965,374659,804718,865549,159960,895798,699306,149569,670461,301754,396150,529853,164847,527033,820808,36310,802800,161159,54204,247565,722219,872276,1043150,102535,775355,278090,991917,163409,225136,217874,1004122,333549,820004,605121,482662,568157,538407,864382,87156,511778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]