SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405675 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405675 [ RunTime:0.003537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595422,330874,573125,103281,1008175,538583,939836,21703,172135,94104,807749,1016702,796206,204597,747773,310413,1009942,879464,699890,356402,8833,281695,1011306,867780,603567,711875,139812,720905,40207,796952,640491,355209,281373,828865,373633,183704,640865,43536,465519,569201,57709,1022808,7069,702096,600330,645387,1034646,636242,351629,357355,657586,562546,25122,330885,635926,619382,691472,595204,11391,36766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]