SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419621 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419621 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326020,79101,277187,1007908,102654,297447,334621,297831,230239,924003,648629,22782,717029,497187,486148,441689,50498,164988,398100,219144,299060,714071,38252,391029,693179,40500,292391,990562,763192,43719,810647,421908,903345,968797,475051,907926,530354,368958,870980,317224,873922,486905,100199,935575,140993,510455,549616,794975,39278,178153,820437,901457,831754,530804,953630,1035826,935576,912918,181279,755006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]