SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516056 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516056 [ RunTime:0.004624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314795,405584,187285,894980,349329,1714,586148,120561,602888,536565,1029502,873920,1007068,219721,709422,625762,155394,410386,544806,434117,738659,223900,557439,135713,84654,301051,620299,463662,258457,808922,736183,902742,659959,630591,328184,360575,469933,447036,16330,138416,683589,238492,1024405,1015848,894915,269575,627821,816401,574303,831209,676483,934730,890636,178598,742774,725699,778925,913162,254539,767518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]