SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011535 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011535 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31087,297348,848337,4486,806911,907171,184997,249779,815540,968455,4492,139216,952719,710825,159732,652976,113070,1005063,374405,710909,882525,193378,361271,364328,957472,792711,300265,707987,352068,560194,575425,505077,932066,81052,10137,547711,626581,370084,525340,367780,751528,279975,985332,126546,201167,584305,773217,177204,523205,219104,515405,19484,401069,872941,127214,103049,860623,582688,41559,811897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001305s ]