SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 153041 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 153041 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017825,226601,101639,728647,93451,977805,811328,1026127,909957,118168,12075,34144,498130,590842,348498,168760,94908,56319,71800,585306,860021,358126,126666,543398,336266,991970,46036,465169,308453,719057,197891,338553,4473,276107,331673,839071,774380,757258,862611,996188,137003,478222,715991,455930,297276,727558,116460,748778,859653,286552,940095,468592,381798,634338,73035,870477,817170,597521,56812,590984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 153041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 153041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]