SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499841 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499841 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311829,92795,442961,239224,514171,14468,727237,886978,758114,375580,910301,262072,117741,586945,396327,412782,289579,801245,795670,483405,546997,676080,225090,391131,905520,832239,777229,489265,340471,1001200,250537,718208,916906,56537,606633,1024029,860183,472139,673541,37132,30594,427837,80859,605864,798141,303625,553333,886404,77134,410559,1042798,722813,154542,1045064,429768,1000257,152246,457063,4368,927757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]