SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48222 LIMIT 1 [ RunTime:0.000816s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48222 [ RunTime:0.001124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888322,34804,512281,770740,768094,698773,394246,974806,888479,526151,479054,560696,896336,108081,336959,802304,894697,721796,322049,510149,799437,909242,546669,54410,450072,70963,115267,474434,338184,325785,30790,606788,468766,461162,97425,963644,752296,31546,938363,1038236,573002,295201,390002,623305,888048,612673,589514,70586,1005259,490928,786040,195791,698953,566835,861640,90487,374938,866162,134275,737606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]