SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462063 LIMIT 1 [ RunTime:0.005688s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462063 [ RunTime:0.005855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366465,827448,738836,62281,371958,277963,873002,251048,720939,1022241,710071,602405,215657,785953,805575,285591,875509,317957,701355,310089,918622,484000,800818,406984,439865,601341,618488,90363,1040337,773419,1028711,1046563,524668,221725,793587,668690,297068,148363,48424,719224,995295,11084,897348,115743,569486,1000488,704274,162373,411293,29359,1003339,1031748,723367,70694,319194,502473,924749,318178,55978,437251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007812s ]