SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435528 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435528 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92630,99741,90618,717374,884392,763598,856922,150380,425703,323492,329399,654382,147983,292121,334255,720944,142125,521639,639689,923021,646965,520073,394875,563981,318008,323751,205989,296902,349132,864871,231057,429810,790462,682436,440985,257042,189086,554009,139739,387210,385510,462183,223659,341691,95536,865358,718810,980028,341696,542723,138162,124827,255859,121982,981684,352970,929674,11313,666436,415683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]