SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196503 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196503 [ RunTime:0.002511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691151,267996,807725,641516,1000022,973447,98384,226744,362623,535659,334470,742129,103165,869258,656053,456041,27632,855494,11527,955721,403283,713164,756977,241001,103031,440403,349246,933208,255173,730847,573564,152944,948503,202339,376737,808796,565417,191520,107398,438385,795728,143288,453437,677479,910181,593021,720071,63219,378745,842315,637184,1047883,175564,513277,568024,754838,438900,1020365,628091,381380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]