SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413179 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413179 [ RunTime:0.003297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289676,714304,69263,550800,780350,275355,384463,845854,241079,220997,856036,431150,803610,349175,942810,294140,268170,1020513,995217,105444,62570,684533,439207,128415,988197,273917,131451,63344,930752,934947,186607,495953,228390,71274,561810,281598,250925,211064,992584,972539,924246,70569,55055,486827,786751,288441,524068,298639,888434,665225,627321,678725,785211,525016,554219,763389,576087,256822,61188,966500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]