SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041161 LIMIT 1 [ RunTime:0.002206s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041161 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975060,929504,676605,83205,617697,928358,442467,1025523,822460,743388,185085,726568,650770,623447,449408,249102,638444,970400,207310,20134,813313,184617,689006,679900,297485,304444,246754,873575,513369,512114,251553,538573,70357,815545,98406,734180,1005150,136663,522816,699816,392234,792968,729922,542457,986467,869213,234135,270138,55932,132668,54471,253513,1005425,325047,180752,218475,373469,18753,708560,1020796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001386s ]