SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429935 LIMIT 1 [ RunTime:0.001730s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429935 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212918,704157,922781,109658,147249,912694,520056,326276,123837,57901,23560,887287,983432,804001,1035810,354033,712004,614331,88387,773768,788160,486917,812741,600248,813159,999997,296310,706266,577265,247880,698131,698110,701607,193020,144711,315817,238400,213800,768634,706754,224986,406696,443777,252348,706483,1008942,149570,196259,178862,599164,745746,933990,781109,961960,531987,952755,652597,201306,443185,7117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]