SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519661 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519661 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117729,13712,239611,784403,917188,158458,648763,862035,996620,681824,613755,1027269,559582,670942,499846,19068,19053,988029,85614,938122,560091,664381,887037,685274,597871,169009,297435,230705,17233,265234,535093,656424,587730,1010789,534364,145469,377452,189712,905998,202449,265014,396550,461249,350847,821670,274160,820635,814540,332536,334058,898858,618183,916017,296028,448120,883542,163799,968677,173124,424391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002035s ]