SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620138 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620138 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168208,491715,1046531,970853,201107,278295,875620,405776,622362,445074,684695,291073,452758,860471,669312,849145,277262,951667,570145,133729,483505,691783,964283,859289,778981,876674,1030511,262987,32323,253412,524886,289491,141604,756292,684803,522261,782653,365618,95052,63401,480357,537993,323561,743651,686628,115345,831379,974123,170530,964437,506474,664912,274743,143912,784370,575942,758026,766131,588831,482651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]