SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291942 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291942 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916948,366911,13915,570762,32745,375839,554253,525132,322453,105845,700689,762813,96388,1870,769058,669642,610396,304268,862371,950928,906580,297643,5154,427874,701208,511580,78278,1031201,243368,50690,222490,854386,1043880,588509,433633,837616,464766,548074,194113,963218,310521,89409,317188,957325,19778,812158,249876,201085,404813,385496,620977,554343,7649,567419,806704,839381,942007,647298,946153,303222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]