SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282820 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282820 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20330,308928,845243,330848,644004,305930,595978,848422,111258,413872,91192,973015,262150,305426,857221,1014939,727890,689968,435053,803478,82239,609000,817059,121330,463492,898158,96244,908986,224500,820788,313378,876033,533768,413606,31339,683249,889160,455512,83244,405939,397789,421336,1010706,994731,663785,904238,75446,500110,680377,401820,201169,655604,704934,354740,292907,978105,1024897,195468,920052,724612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]