SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477051 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477051 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516150,605963,876269,622628,117861,241684,990627,120799,189390,444735,620532,91909,586739,1000038,1037300,455760,767561,236551,487426,202780,386652,910791,455097,556283,404271,330913,664206,992126,266697,770981,210828,428734,730173,503430,29607,238870,719632,1027541,395847,612923,268986,911547,636519,921593,587420,741177,723151,784762,6406,641048,303731,850203,817599,116928,290637,665741,625656,243669,204056,1022024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]