SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 662941 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 662941 [ RunTime:0.003079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407428,588908,75750,689591,674780,637059,928949,476936,390499,201096,114361,178031,938478,287346,640542,394312,711174,797308,350614,801492,591142,747087,924043,820791,758280,510641,761371,729721,217396,792009,163885,673469,1022328,580792,1007367,739937,170742,368374,75092,729166,257871,30149,381824,221563,321759,14484,917485,777892,304177,146261,231635,394024,948252,584648,148031,838215,403937,19792,918896,654658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 662941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 662941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002642s ]