SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5185 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5185 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749251,127929,154723,448133,37888,910875,1008805,345226,477551,308877,278890,2582,197164,947641,470473,273851,246846,646923,254694,319848,655530,208718,292383,254931,600510,528605,419908,948379,276223,850650,604467,119696,994715,127800,930858,368842,725522,282495,59265,404480,502690,464113,215671,146306,864089,936715,200983,628228,893713,786011,627164,804849,714471,1033862,857906,153124,953828,908764,725232,675883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]