SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003481s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268084 LIMIT 1 [ RunTime:0.002105s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268084 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614193,955920,407394,855262,685620,497898,417816,757116,528381,181113,898206,533580,283402,843959,760892,459300,133792,1026832,495819,338299,670198,553109,595591,376835,984833,257407,350529,210599,124595,272387,55697,1029271,376255,548670,467798,649891,550378,677174,1013110,179663,654008,203177,352537,663417,781841,556916,792848,415323,533055,901154,143780,823551,980054,930173,933162,325070,737080,397518,825908,548591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]