SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568351 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568351 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576177,1014143,185429,1043067,252261,108804,571867,864264,972049,164174,323876,320189,144493,764895,951527,196497,25451,743056,1048219,344962,953688,657692,741323,783428,85698,361545,407765,809951,101954,81767,446806,996717,726058,293970,358803,23903,804154,945849,769174,58889,995210,863889,923521,603229,1006122,165870,763066,311669,658483,166035,14562,503774,182388,215298,123454,380265,620531,948057,392582,109251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002197s ]