SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550401 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550401 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375485,216443,823573,85858,5112,384459,501999,422581,621574,83035,66731,12741,92400,856407,925206,496245,215138,1038945,322408,71743,538352,960873,148859,224480,458001,283158,275687,765642,408459,822097,356854,221803,190322,515483,665770,538377,614323,672344,445359,1024154,47919,55882,891201,7478,561285,498183,839307,857063,575427,637622,214743,542413,574426,673111,154151,667519,1009202,412279,637198,224055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]