SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4618 LIMIT 1 [ RunTime:0.000587s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4618 [ RunTime:0.002786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336333,489742,283641,999673,48328,797999,490578,212242,133412,834446,698854,757193,503188,195445,538340,1007622,1035029,453135,325805,298218,824199,113482,149896,884600,232530,31908,1020836,1017390,74275,176405,774928,355198,20088,366763,896041,718972,255525,554807,792233,738827,396773,491765,167349,489145,100634,475082,752980,557855,988919,455208,66453,699698,714778,249162,903325,689938,710247,1019152,204545,485491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]