SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397993 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397993 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413299,1033283,844000,500655,660951,861371,1038062,254022,175278,305515,964388,754584,579471,400957,507062,332156,1035147,1048397,592153,1004503,166744,17316,288036,5194,620040,793112,267990,801145,902932,902083,336828,847608,436335,568796,559353,27171,245969,142607,944029,395165,230212,606995,33867,37010,1019143,684195,878204,421479,907930,217172,848741,69201,206295,839134,245393,199186,911314,464826,347632,402733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]