SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545258 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545258 [ RunTime:0.003428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283042,359658,1020428,728164,158785,718609,366824,359066,577192,606893,1037311,592305,448287,125120,188449,883063,403357,365017,70547,561724,954929,45470,882090,426326,701084,107444,941880,31420,963131,122883,664567,694834,697077,437786,275582,338131,443354,1016439,1025799,886349,864256,388379,941140,868992,378246,960738,309257,432576,855331,1040962,430056,395070,928288,287598,138413,883261,788426,191187,1021425,168771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]