SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007268 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007268 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403499,215758,185921,772351,1031641,115371,498714,544640,840075,49259,622376,610877,551104,203198,438214,542540,120078,967696,310937,113757,82458,661185,229098,514263,113501,66666,229975,1042706,44336,284451,296668,481029,545018,172915,825105,301169,201569,60510,923000,571760,903635,784160,798472,930775,725330,758780,974080,987406,922637,806008,395156,497144,763886,749099,84014,109481,1020469,458759,807164,842421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]