SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484801 LIMIT 1 [ RunTime:0.004690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484801 [ RunTime:0.003872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369961,813705,865767,474508,291753,20626,957268,279812,970781,922136,239037,438743,128256,801551,936297,698161,566492,97834,747371,516162,391711,119754,176016,1042281,11982,895547,535286,709605,69207,993403,474004,103371,853152,445174,785791,455216,659906,839706,823193,1022049,1021358,916516,208103,1027058,308150,39932,353973,284854,114723,145282,55687,982577,732301,329969,381181,234679,932706,270156,292479,364468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]