SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535217 LIMIT 1 [ RunTime:0.000942s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535217 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148318,244002,655621,587421,874432,209801,709563,879158,6298,811124,221585,113347,256217,12126,394920,309456,163593,782302,149830,963133,189284,125435,114978,1004622,398628,303268,499238,778209,357646,997566,140989,232997,565449,202408,1034641,150269,913000,868895,824598,931043,905246,8030,759491,920186,337568,505621,11102,574651,851184,598208,384897,779822,421481,791477,96037,762085,583610,748505,791773,274265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]