SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459469 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459469 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047120,96551,302727,909133,98416,373953,139051,908078,210656,521318,779704,290749,989223,119082,293230,874138,550743,22968,365824,271066,383791,780959,806687,87892,1001260,362665,79159,506686,973439,78543,883170,707694,120873,29513,211463,971913,144905,566168,1017849,237203,293839,449334,212776,996823,269101,145711,394680,1014616,650719,344065,27765,715213,486270,799101,424778,839970,232629,227840,1048651,882563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]