SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403182 LIMIT 1 [ RunTime:0.000808s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403182 [ RunTime:0.002392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76515,191522,215043,990951,416386,675783,691080,606589,230866,28180,788394,799917,1039681,873642,906367,32007,857590,143808,803799,279638,764119,580147,139913,523854,646012,852009,1037572,899400,253154,837953,458433,554844,393839,415759,406695,335202,952986,342844,272431,543033,752178,377330,69177,602236,574560,700185,825799,3955,120290,901503,359059,470616,665564,38303,673254,430756,245167,28176,184648,43223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002731s ]