SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040169 LIMIT 1 [ RunTime:0.000685s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040169 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012353,197390,157416,241550,120085,579100,876621,452412,577666,639112,173691,439578,728505,365504,338549,483292,452101,154416,24038,475517,179199,416118,1036134,587297,550477,540970,699594,118045,849172,1005663,299948,74443,607561,778923,242284,384044,74504,763614,191366,330217,515121,588136,561344,885696,436826,816203,614419,233838,268512,73030,221661,311055,161197,118644,297589,677378,119688,273551,992468,685269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]