SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526201 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526201 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519571,66020,765603,813882,678642,583983,860442,100830,827197,25943,1042090,695174,465009,948886,383465,13300,70162,871255,197088,899100,811023,529399,1001417,721523,621100,957868,610834,949446,628174,1018731,1034629,178550,281174,217464,183942,226866,42640,282649,369972,825511,634211,656324,40507,867292,640968,527565,447200,1016602,545968,1046048,226552,61629,1034358,724178,821603,475441,693992,662370,851503,1042405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]